articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Accesorii Lead Clip Mostiro Heavy+Bolt+Con Soft Maro

Accesorii Lead Clip Mostiro Heavy+Bolt+Con Soft Maro

4111
Livrare imediată!

5,90Lei

ANTENA MOSTIRO SCHIMB PLUTA 3.0MM 5BUC/PLIC
Exclusiv online!

ANTENA MOSTIRO SCHIMB PLUTA 3.0MM 5BUC/PLIC

2829
Livrare 48-72 ore

4,00Lei

Blocaj Boilies/Porumb Mostiro Small

Blocaj Boilies/Porumb Mostiro Small

4128
Livrare imediată!

3,30Lei

ACCESORII TULIP SOFT MARO MOSTIRO 10 BUC
Exclusiv online!

ACCESORII TULIP SOFT MARO MOSTIRO 10 BUC

4092
Livrare 48-72 ore

3,40Lei

Aligner Mostiro Brown S (10Buc)

Aligner Mostiro Brown S (10Buc)

4187
Livrare imediată!

5,80Lei

ACCESORII LEAD CLIP +CON SOFT MARO MOSTIRO (5+5 BUC)

ACCESORII LEAD CLIP +CON SOFT MARO MOSTIRO (5+5 BUC)

4102
Livrare imediată!

4,80Lei

SPIN MOMEALA MOSTIRO BAIT STING 10MM 10BUC

SPIN MOMEALA MOSTIRO BAIT STING 10MM 10BUC

4239ms
Livrare imediată!

13,90Lei

CLESTE MOSTIRO PTR PLANTAT (1 BUC)

CLESTE MOSTIRO PTR PLANTAT (1 BUC)

4457ms
Livrare imediată!

50,00Lei

Aligner Mostiro Green S (10Buc)

Aligner Mostiro Green S (10Buc)

4189
Livrare imediată!

5,80Lei

Aligner Mostiro Clear S (10Buc)

Aligner Mostiro Clear S (10Buc)

4188
Livrare imediată!

3,70Lei

ACCESORII LEAD CLIP INOX +CON SOFT VERDE MOSTIRO

ACCESORII LEAD CLIP INOX +CON SOFT VERDE MOSTIRO

4106
Livrare imediată!

7,90Lei

ACCESORII TULIP SOFT MOSTIRO VERDE 10 BUC

ACCESORII TULIP SOFT MOSTIRO VERDE 10 BUC

4093
Livrare imediată!

3,90Lei

Teu Mostiro Plastic Pentru Monturi 2 Buc

Teu Mostiro Plastic Pentru Monturi 2 Buc

mos-00000553
Livrare imediată!

3,67Lei

APARAT MOSTIRO LEGAT CARLIGE MANUAL

APARAT MOSTIRO LEGAT CARLIGE MANUAL

ai-0522l-e
Livrare imediată!

10,10Lei

ACCESORII LEAD CLIP NEW +CON SOFT MOSTIRO(5+5 BUC)
Exclusiv online!

ACCESORII LEAD CLIP NEW +CON SOFT MOSTIRO(5+5 BUC)

4110
Livrare 48-72 ore

4,61Lei

Line Aligner Mostiro Brown (10Buc)

Line Aligner Mostiro Brown (10Buc)

4168
Livrare imediată!

5,80Lei

CUTIE VARNIS MOSTIRO SILICON EXTRAFIN PTR PLUTE

CUTIE VARNIS MOSTIRO SILICON EXTRAFIN PTR PLUTE

4455ms
Livrare imediată!

9,70Lei

Inimioare Mostiro Rosii 10buc/pac

Inimioare Mostiro Rosii 10buc/pac

mos-00000552
Livrare imediată!

4,70Lei

Line Aligner Mostiro Clear (10Buc)
Exclusiv online!

Line Aligner Mostiro Clear (10Buc)

4167
Livrare 48-72 ore

3,40Lei

OPRITOARE MOSTIRO LUMINOASE PENTRU CARLIG 5 BUC
Exclusiv online!

OPRITOARE MOSTIRO LUMINOASE PENTRU CARLIG 5 BUC

ai-rm88-s
Livrare 48-72 ore

3,20Lei

Afişare 1 - 20 din 64 (4 pagini)
Queries: 13, Total time: 229.518 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '4ff4c49955bc9886d439119baf'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (227.287)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%accesorii%' AND pd.tag LIKE '%mostiro%')) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:697
5 (0.157)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1547
6 (0.475)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.201)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1202
8 (0.116)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1221
9 (0.104)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:982
10 (0.554)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:904
11 (0.109)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.104)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.111)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38